| |
|
|
|
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
FAQ
What functions are supported (Sum(),Year(), etc.)?
All functionality from the .NET System.dll framework are supported. For example:
Basic math: [c0r0]+[c0r1]
System.Math namespace: Math.Pow(1+[c1r7],2)
Strings: `[c0r1]`.Trim().Replace(`$`,``).Substring(0,1)
Dates: DateTime d=new DateTime([c1r0]);return d.Year;
Formula cell references such as `[c0r1]` are replaced by the value of the cell, then evaluated. (Note that the value of a date cell is the number of ticks.) So the above examples might look like this before being evaluated:
Basic math: 100+200
System.Math namespace: Math.Pow(1+.045,2)
Strings: `$57`.Trim().Replace(`$`,``).Substring(0,1)
Dates:DateTime d=new DateTime(632272996777884556);return d.Year;
Formula cells are created like this:
Spread1.AddCell(new FormulaCell(1,6,`[c1r4]*[c2r6]`,`Formula`,NumericFormats.ToTheDollar));
See below for more examples of how formula cells work. Note also that there are two kinds of formulas, simple and multiline. The example below shows both types of formulas.
Code used in this example
Initialization of a spreadsheet
Using Mayersoft.Web.Controls;
private void Page_Init(object sender, System.EventArgs e)
{
Spread1.LicenseKey=`eL!NJ@2H3aF`;//sample key
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Spread1.Columns.Add(new Column(150));
Spread1.Columns.Add(new Column());
Spread1.AddCell(new Cell(0,0,`Item 1`,`Label`));
Spread1.AddCell(new Cell(0,1,`Item 2`,`Label`));
Spread1.AddCell(new Cell(0,2,`Total`,`Label`));
Spread1.AddCell(new Cell(0,3,`Div by pct`,`Label`));
Spread1.AddCell(new Cell(0,4,`Result`,`Label`));
Spread1.AddCell(new Cell(0,5,`Price |
|
|
|
NEWS
So far, nothing for that!
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| |
| Airetec.com | 0 | Win 95Win CE / Pocket PC /NT/2 | E450 | Downloads: 1686 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » VLFullScreen Ver 1.0 (Four Developers Pack) 1.0
|
| VLFullScreen allows your application to acquire all of the available screen area as and when desired with absolutely minimal coding (how about zero !). Complete control on the font and text lets you use it for applications developed for non-English lan ... |
|
| Viklele.com | 0 | Win 95/NT/2000/XP/98/ME | $74.75 | Downloads: 1843 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Boolnet Easy Bar Chart 1.0 1.0
|
| Boolnet Easy Bar Chart 1.0 Boolnet Easy Bar Chart 1.0 will improve your web project whenever you need an elegant presentation with minimum work. To install you just need to drop the application file to the web executable directory and start using. A ... |
|
| Boolnet.com | 0 | Win NT/2000 | $19.99 | Downloads: 1733 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Boolnet Easy Chart Pack 1.0 1.0
|
| Boolnet Easy Chart Pack 1.0 Boolnet Easy Chart Pack 1.0 contains the powerful components Easy Pie Chart 1.0 and Easy Bar Chart 1.0. This applications will improve your web project whenever you need an elegant presentation with minimum work. To install ... |
|
| Boolnet.com | 0 | Win NT/2000 | $29.99 | Downloads: 1784 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Obsidium.de | 0 | Win 95/NT/2000/XP/98/ME | $59 | Downloads: 1755 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Search32 v.6x - 5 copies v.6x
|
| Search32 is a program for searching in a large number of text files stored on personal computer or in local area network. Provides very fast search using preliminary created index files. This new vesion contains functions opened for developers, who want t ... |
|
| Anetsoft.com | 0 | Win 95/NT/2000/XP/98/ME | $150 | Downloads: 1773 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - Windows (download) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95/NT/2000/XP/98/ME | $425 | Downloads: 1683 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - Windows (CD Box) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95/NT/2000/XP/98/ME | $495 | Downloads: 1654 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - MacOS (download) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Macintosh | $425 | Downloads: 1715 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - MacOS (CD Box) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Macintosh | $495 | Downloads: 1658 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » .NET Memory Profiler 1.0
|
| .NET Memory Profiler is a tool for the .NET Common Language Runtime that allows the user to track all instances that are allocated on the garbage collected heap (GC heap). The user can collect snapshots of the GC heap and get information about the instan ... |
|
| Scitech.se | 0 | Win 2000/XP | $65 | Downloads: 1948 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW Upgrade (Electronic) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95Macintosh /NT/2000/XP/98 | $125 | Downloads: 1542 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW Upgrade (CD Box) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95Macintosh /NT/2000/XP/98 | $150 | Downloads: 1662 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » kSkin Skin Engine 1.0
|
| kSkin - custom skin form implementation library The kSkin library developed by Kruse Software allows you to create distinctive, runtime, customizable user interfaces for your .NET applications. The kSkin library allows you to switch between different int ... |
|
| Kskin.net | 0 | Win 95/NT/2000/XP/98/ME | $349 | Downloads: 1771 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TransPlace Distribution Utility Professional 1.38
|
| TransPlace Pro is the ultimate solution for long-term security. TransPlace is a file distribution tool with a lot of options: * Remote selection of the destination directory * Ultra Secure Password protection (PRO-VERSION) * Long term security for your ... |
|
| Orontesprojects.com | 0 | Win 95/NT/2000/XP/98/ME | $200 | Downloads: 1760 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TransPlace Distribution Utility Professional + Keygen 1.38
|
| TransPlace Pro is the ultimate solution for long-term security. A keygenerator to make keys for your correspondents is included. With this version you can make ultra secure system-locked viewer keys. TransPlace is a file distribution tool with a lot of ... |
|
| Orontesprojects.com | 0 | Win 95/NT/2000/XP/98/ME | $500 | Downloads: 1689 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Know How Library 1.0
|
| The program Know How Library is a database where you can store your collected tips, tricks and components. With the integrated search function you are able to find the tips and components you are looking for. ... |
|
| T-online.de | 0 | Win 95/NT/2000/XP/98/ME | E17.2 | Downloads: 1718 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Sniff`em Non-Profit 1.1 License 1.1
|
| Sniff`em™ is a competitively priced, performance minded Windows based Packet sniffer, Network analyzer and Network sniffer, a revolutionary new network management tool designed from the ground up with ease and functionality in mind. This License is st ... |
|
| Sniff-em.com | 0 | Win 95/NT/2000/XP/98/ME | $120 | Downloads: 1661 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Aspose.Chart 1.0 Winform License Basic Edition
|
| Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ... |
|
| Aspose.com | 0 | Win 2000/XP | $99 | Downloads: 1730 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Aspose.com | 0 | Win 2000/XP | $99 | Downloads: 1692 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
